package com.huangpuweb.api.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class LxmSignageErrorRowMapper implements RowMapper<LxmSignageError>{

	@Override
	public LxmSignageError mapRow(ResultSet rs, int rowNum) throws SQLException {
		LxmSignageError  lj= new LxmSignageError();
		lj.setId(rs.getInt("id"));
		lj.setRoad_name(rs.getString("road_name"));
		lj.setAddress(rs.getString("address"));
		lj.setNumber(rs.getString("number"));
		lj.setLamplight_number(rs.getString("lamplight_number"));
		lj.setStyle(rs.getString("style"));
		lj.setLength(rs.getString("length"));
		lj.setTall(rs.getString("tall"));
		lj.setDistance(rs.getString("distance"));
		lj.setElevation(rs.getString("elevation"));
		lj.setNotification(rs.getString("notification"));
		lj.setIssue_date(rs.getString("issue_date"));
		lj.setSpecification(rs.getString("specification"));
		lj.setHeight(rs.getString("height"));
		lj.setExamine_date(rs.getString("examine_date"));
		lj.setSafety(rs.getString("safety"));
		lj.setSuggest(rs.getString("suggest"));
		lj.setResult(rs.getString("result"));
		lj.setType(rs.getInt("type"));
		lj.setReview_date(rs.getString("review_date"));
		lj.setReview_result(rs.getString("review_result"));
		lj.setDz_comment(rs.getString("dz_comment"));
		lj.setHidden_danger_desc(rs.getString("hidden_danger_desc"));
		return lj;
	}

}
